package com.jinzhi.jzweb.dao;

import com.baomidou.mybatisplus.plugins.Page;
import com.jinzhi.common.base.BaseDao;
import com.jinzhi.jzweb.domain.moduleConfig.CareStuSignUpComRealityDO;
import com.jinzhi.jzweb.pojo.StuSignUpTeamVo;
import com.jinzhi.jzweb.pojo.moduleConfig.ExaminationCostStatisticVo;
import com.jinzhi.jzweb.pojo.moduleConfig.NationVo;
import com.jinzhi.jzweb.pojo.statistics.StuResultsTeamAVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *
 * <pre>
 * 考生报名
 * </pre>
 * <small> 2023-05-05 08:52:02 | lance</small>
 */
public interface CareStuSignUpComRealityDao extends BaseDao<CareStuSignUpComRealityDO> {


    List<StuSignUpTeamVo> sumTeamStuSignExam(@Param("name")String name);

    List<StuSignUpTeamVo> sumOneStuSignExam(String name);

    Integer MaxNum(@Param("cbatchId")Long cbatchId);

    /*查询民族*/
    List<NationVo> queryCountByNation();

    /*查询性别占比*/
    List<NationVo> queryProportionBySex();

    /*查询年龄柱状图*/
    List<NationVo> queryAgeList();

    /* 年龄最大值、最小值、平均值 */
    ExaminationCostStatisticVo queryProportionByAge();

    /*查询省份数量*/
    Integer queryProvinceCount();

    Integer queryNumByUnitName();

    List<StuResultsTeamAVo> getTeam(@Param("page") Page page,@Param("decryptAll") Integer decryptAll,@Param("decrypt") Integer decrypt);

    void clearDraw();

}
